Use Cases

ConceptName

Insert

1. Does a duplicate name already exist?
   • Don't need to worry. JPA will throw an exception since it's a unique column.
2. Is it a primary name? Only 1 primary name per concept is allowed.
   1. Is there another primary name for that concept already?
      • Yes = throw exception
      • No = continue

Delete

1. Is it a primary name?
   • Yes = throw exception
   • No = delete it

Update

1. Does a duplicate name already exist?
   • Don't need to worry. JPA will throw an exception since it's a unique column.
2. Is it a primary name? Only 1 primary name per concept is allowed.
   1. Is there another primary name for that concept already?
      • Yes = throw exception
      • No = continue
3. Is it a non-primary name?
   • Make sure the concept has at least 1 primary name